﻿CREATE PROCEDURE [dbo].[Itinerary_getitineraryservice]
	@ItineraryServiceId bigint
AS

SET NOCOUNT ON
SET XACT_ABORT ON
SET ANSI_PADDING ON

DECLARE @nStatus tinyint
DECLARE @key bigint

BEGIN

	SELECT
		[ServiceUuid],
		[Name],
		[Type],
		[IsRequestResponse],
		[Position],
		[Stage],
		[Id],
		[NextId],
		[BusinessName],
		[ItineraryName],
		[ItineraryMajorVersion],
		[ItineraryMinorVersion],
		[ModifiedBy],
		[ModifiedOn]
	FROM
		[dbo].[ItineraryService]
	WHERE
		[ItineraryServiceId] = @ItineraryServiceId
	IF @@ROWCOUNT = 0
		RETURN -1

END

GO
--GRANT EXECUTE
--    ON OBJECT::[dbo].[Itinerary_getitineraryservice] TO [ESBUsers]
--    AS [dbo];